<?xml version="1.0" encoding="iso-8859-1" ?>
<dataset name="">
  <tables>

    <table name="workareas" update="0.2.0.8">
      <column name="id" type="integer" AutoIncrement="true" AutoIncrementStep="1" Primarykey="true" />
      <column name="name" type="string" />
    </table>
    <!--
    <table name="workareas" update="0.2.0.8">
      <relations>
        <relation type="ParentRelation" name="fk_workareafile">
          <parent name="files" column="id"/>
          <child name="fileslink_workarea" column="file_id"/>
        </relation>
        <relation type="ParentRelation" name="fk_workareafile">
          <parent name="workareas" column="id"/>
          <child name="fileslink_workarea" column="workarea_id"/>
        </relation>
      </relations>
    </table>
-->
    <table name="fileslink_workareas" update="0.2.0.7">
      <column name="id" type="integer" AutoIncrement="true" AutoIncrementStep="1" Primarykey="true" />
      <column name="file_id" type="integer" />
      <column name="workarea_id" type="integer" />
    </table>

    <table name="fileslink_tests" update="0.2.0.9">
      <column name="id" type="integer" AutoIncrement="true" AutoIncrementStep="1" Primarykey="true" />
      <column name="file_id" type="integer" />
      <column name="test_id" type="integer" />
    </table>
    <!--
    <table name="tests" update="0.2.0.6">
      <relations>
        <relation type="ParentRelation" name="fk_testfile">
          <parent name="files" column="id"/>
          <child name="fileslink_tests" column="file_id"/>
        </relation>
        <relation type="ParentRelation" name="fk_testfile">
          <parent name="tests" column="id"/>
          <child name="fileslink_tests" column="test_id"/>
        </relation>
      </relations>
    </table>
-->
    <table name="tests" update="0.2.0.5">
      <column name="filename" delete="true" />
    </table>
    <table name="files" update="0.2.0.4">
      <column name="id" type="integer" AutoIncrement="true" AutoIncrementStep="1" Primarykey="true" />
      <column name="origfilename" type="string" />
      <column name="filename" type="string" />
    </table>

    <table name="tree" update="0.2.0.1">
      <column name="id" type="integer" AutoIncrement="true" AutoIncrementStep="1" Primarykey="true" />
      <column name="name" type="string" />
      <column name="parent_id" type="integer" />
    </table>

    <table name="treelink_test" update="0.2.0.1">
      <column name="test_id" type="integer" />
      <column name="tree_id" type="integer" />
     <!--
      <relations>
        <relation type="ParentRelation" name="fk_testtree">
          <parent name="tests" column="id"/>
          <child name="treelink_test" column="test_id"/>
        </relation>

        <relation type="ParentRelation" name="fk_tree">
          <parent name="tree" column="id"/>
          <child name="treelink_test" column="test_id"/>
        </relation>

      </relations>
      -->
    </table>

    <table name="grades_link" update="0.2.0.2">
      <column name="grade_id" type="integer" />
      <column name="subject_id" type="integer" />
      <column name="student_id" type="integer" />
    </table>

    <table name="students" update="0.2.0.3">
      <column name="student_id" type="integer" />
    </table>

    <table name="classes" update="0.2.0.3">
      <column name="previousclass_id" type="integer" />
    </table>
    
    </tables>
</dataset> 
